//开始时间
DATECALCULATE(DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())),-15,false)
//结束时间
DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW()), 23,59,59)



// 数据查询
// 等值查询pp__equal__value 或 pv = ${p__equal__value} 或 v = ${p}
// 范围查询pp__between__start p__between__end v between ${p__between__start} and ${p__between__end}
// IN查询pp__in__valuev in (${p__in__value})


// 场景           页面参数            SQL参数                               模板示例
// 等值查询         p                   p__equal__value 或 p                 v = ${p__equal__value} 或 v = ${p}
// 范围查询         p                   p__between__start                    p__between__endv between ${p__between__start} and ${p__between__end}
// IN查询           p                  p__in__value                         v in (${p__in__value})
